import pandas as pd
import matplotlib.pyplot as plt

data = pd.read_excel("frames.xlsx")

plt.hist(data[0],rwidth=0.5)
plt.show()

# res = []
# avg = []
# fangcha = []
# cur = 0
# for i in range(20):
#     num = data[1][i]
#     sum = 0
#     for j in range(int(num)):
#         sum += data[0][j+cur]
#
#     res.append(sum/num)
#
#     sum2 = 0
#     for j in range(int(num)):
#         sum2 += (data[0][j+cur] - sum/num)**2
#     fangcha.append(sum2/num)
#     cur += num
#
#
#
#
# # print(res)
# print(fangcha)
